SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001668s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 214203 LIMIT 1 [ RunTime:0.000571s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 214203 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569301,921855,268678,515277,952055,742683,772814,773486,981355,891393,220268,688604,891286,878790,402662,714576,790952,715436,49450,637630,478431,295958,595571,780640,414627,570337,512247,858069,726206,1032885,368672,4278,830723,625115,844597,993378,764008,639537,724688,88013,81561,447074,987425,634785,867582,612014,387787,190605,1028149,540015,621204,211200,130739,106634,519764,974780,25492,822025,145911,267906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 214203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000653s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 214203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001164s ]