SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341197 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341197 [ RunTime:0.001870s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502756,733293,322240,751301,486188,373061,294111,853945,314435,66697,425469,437504,308871,153560,900739,76105,702477,921938,548731,413284,111480,628457,560566,523866,687749,84231,744132,264758,934694,435542,982525,147289,784715,753027,64418,974438,60499,95137,327776,996018,166130,289927,997046,138254,8317,8495,401342,830446,13564,883464,305900,188884,952941,362003,880538,547335,857948,742030,708663,95086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]