SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101039 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101039 [ RunTime:0.003017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720747,289413,755565,227332,892393,784278,109134,536870,586988,984651,746301,986999,696063,228812,746318,983486,680025,694754,683018,35468,418066,570966,1005898,1024751,677502,511201,603179,531806,932133,490123,88956,744842,66054,278526,587764,70267,340290,1030360,579578,105907,935092,859746,172627,362581,128102,313333,164070,495539,141824,180848,897583,513847,9969,10556,651909,1003988,577221,399617,140502,497508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]