SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586733 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586733 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012615,1014172,611289,550234,479058,190992,322343,33586,792251,455357,141920,566247,570560,107031,13476,643873,128330,1038590,570646,497218,677211,918651,71962,106477,656073,757373,116647,688628,114005,465111,261500,812313,533462,919990,817560,153472,51035,520122,331871,1036733,674061,651672,485519,822183,72226,886837,399462,330280,761060,140031,660261,467127,501558,11653,59508,263877,65532,367815,542626,98908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586733 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586733 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]