SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105583 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105583 [ RunTime:0.001942s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150527,128986,538742,863756,567417,822627,10986,749821,1012368,632580,641814,797582,99080,878654,919351,338749,993053,804654,722912,405582,478666,877038,628333,508013,820794,68886,949304,676311,351428,334412,37703,538501,492311,540584,322299,883091,457658,1025280,677654,246382,771689,163984,402902,908837,1024747,552764,268694,320796,508374,737585,587931,500302,26198,774510,169706,1040437,1040499,1005764,785787,159399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]