SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576413 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576413 [ RunTime:0.001407s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12212,479566,346119,608728,1030179,632653,684414,277175,254946,833577,1020982,656379,432568,693932,390100,277918,227465,63480,897721,523168,605493,106821,864180,834740,916606,720293,193855,992310,1030127,385877,783732,274223,8566,641757,971223,560156,236282,770553,492814,162854,79970,1021252,978975,243390,876675,996289,664183,247343,642093,90809,353152,257434,132992,889149,210206,427030,163958,372670,932445,886320) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 576413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]