SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54150 LIMIT 1 [ RunTime:0.001224s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54150 [ RunTime:0.002723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (676508,660976,481246,488865,902918,954452,818348,447222,559256,198219,400120,165998,985195,257125,901770,884528,249639,117221,932548,270680,394853,464609,943163,283639,759627,583146,142356,163705,602812,780557,618638,165911,523893,702050,853357,1020078,78452,334758,462419,626447,706529,949738,317302,468606,17013,1040753,345437,649725,966483,768333,414778,784890,84739,441885,590683,425328,853817,84189,422708,886371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]