SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001552s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328178 LIMIT 1 [ RunTime:0.000641s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328178 [ RunTime:0.001468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61244,463411,734937,880392,69195,734181,154484,268792,12887,223678,795391,444495,171841,40410,264589,271268,972090,57674,468885,234001,911957,926466,795729,571731,609974,128790,793893,865634,248936,1016997,967351,45124,946369,732608,525348,852742,98153,137126,819636,423407,473693,183662,168577,172721,540077,280756,763124,69084,1042229,965051,9946,84634,541261,676168,471022,361282,916969,987340,921657,751884) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]