SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002076s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 332804 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 332804 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025523,795293,992206,488795,434065,172691,268800,857867,177440,55473,527907,764993,392013,595141,214807,564828,527401,731878,859419,828456,603845,1040356,967336,781989,107826,363945,1023381,218259,553628,359750,155542,341260,947632,741625,847380,46295,825508,835957,392217,454624,181559,612441,31640,533315,861522,1046948,960416,254595,159693,904497,596372,687073,618991,491110,553279,382010,867451,1038782,456205,405369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 332804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 332804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]