SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35640 LIMIT 1 [ RunTime:0.000562s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35640 [ RunTime:0.003488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526454,399380,18571,672806,596743,13158,49808,50857,376013,614022,29360,808492,186820,471331,970392,67978,658999,821992,759719,385396,592821,254584,1033487,695056,756136,360561,541007,908122,744314,271175,144587,818314,455392,57192,652266,948464,980055,583433,333268,904501,448712,10819,726299,555172,473146,42725,753097,926694,444174,577143,1041849,1012688,299631,715115,786320,104260,366712,2508,688925,753063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]