SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002574s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34301 LIMIT 1 [ RunTime:0.001871s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34301 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833651,478389,670550,22171,532884,724019,751955,65725,771348,162865,343544,1951,273735,384271,460688,39954,64345,301964,524705,962556,919793,991228,475360,881285,784780,637703,98827,332025,17319,585403,661044,329596,53899,726391,542794,413312,59838,118315,481838,532736,603957,959950,200320,1008392,162317,974010,14846,473740,813680,986951,556421,563846,113870,9040,676985,126586,264394,226808,358432,872010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001176s ]