SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560654 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560654 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (77017,865553,780463,690769,1002310,200485,20934,695828,361882,98305,282114,709171,122545,696872,919931,589250,259966,436530,1003520,31763,948414,388749,280927,200825,1020749,684173,993583,291249,302830,543520,676738,616514,710124,551862,70526,798895,329736,743625,302570,380477,97581,928789,52990,384731,667678,22782,282065,678737,725545,918094,855571,776887,898923,1047019,894195,692969,463758,80611,92367,532292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]