SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510581 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510581 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475127,195750,671296,467780,967832,605787,898845,346362,177998,1010475,305535,850047,586326,516495,925132,361813,968782,800653,311129,910924,910962,565350,548650,54748,395943,432462,513882,662855,185924,47009,999761,1022936,844813,566263,199760,1009597,770699,438482,914073,163087,901956,384439,596040,931106,256137,325110,810003,416317,884739,60225,735904,691391,985424,545113,575414,380209,413594,1027214,951743,889408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]