SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457548 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457548 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52650,506436,84490,1039702,244082,940735,916699,769203,475513,851629,944935,554569,825810,27239,670785,569985,869055,667739,660093,582411,953293,372427,1048235,543825,1039481,996615,648238,498365,839213,766404,554180,1019215,902551,315828,991335,571174,603983,643055,427979,585075,1012921,705969,574889,581019,607966,937480,624654,775693,442982,371771,992643,82284,89180,780858,516497,322317,957787,735259,856766,110890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457548 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457548 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]