SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404027 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404027 [ RunTime:0.001932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (965146,167151,827153,928739,1044742,376017,618349,98319,606976,998271,318237,919683,49245,770263,880113,149015,598397,535140,108973,661895,874756,224679,496307,267354,1004828,473081,649213,203792,466705,481284,392244,484682,538652,257327,464962,98845,906204,1005812,1005975,573630,728738,205689,805783,140914,622467,248620,897582,926557,564328,27881,153867,1023712,1019165,340241,112561,416277,817097,297852,799714,3092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003940s ]