SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001776s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402136 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402136 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117613,94483,89176,520774,753338,649385,687933,533183,321632,285311,661720,869834,532005,269436,681549,175164,772442,538171,310411,323169,236192,762459,653179,362774,952034,157059,502516,977496,315973,240563,481758,250096,748988,19252,817268,797657,704372,452118,207809,1044198,492424,148544,1029752,661961,479532,1007214,683980,1048756,988839,841645,432535,526840,732606,702305,264221,778236,433688,874008,213531,25886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402136 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402136 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]