SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102891 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102891 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526079,532573,66305,983635,349779,690670,603000,810657,264265,456460,532907,782361,384219,805743,685597,173535,1025318,478195,986269,300062,32297,629373,145818,596112,46684,935792,310192,300202,250580,271009,465177,110591,226305,499871,341989,136127,793680,416470,194811,163441,33886,509516,1000248,906263,627302,852253,517226,364817,927653,636659,908181,147751,1004008,886497,337706,1029186,863315,526115,173116,690607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]