SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861098 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861098 [ RunTime:0.001986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721121,381979,588062,15890,401470,34330,529447,143513,583010,18370,203619,441789,1047356,616036,372292,533897,172137,493139,656535,164791,777750,950287,741033,587782,578633,461125,310095,160473,827713,367151,471419,844753,481755,499680,836824,739187,402377,936442,1039333,1033770,50298,154392,980619,828796,210382,233305,116377,509295,153399,1008271,107547,1000349,1040564,548438,532744,37333,630998,502402,653505,931002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]