SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380540 LIMIT 1 [ RunTime:0.000501s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380540 [ RunTime:0.002285s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132982,667344,7042,869702,938684,67007,151514,499120,205533,1034958,43089,1042995,765622,967249,317036,1007929,742579,160879,1043968,313920,326693,697622,141473,396438,238403,770127,253574,619355,807108,93397,981601,18980,410970,335347,49219,766969,75568,1039317,74610,631694,303085,21680,67950,375984,95364,513472,275858,1043668,604962,218732,1034182,945404,791112,823152,576823,225223,51919,241511,530307,239143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000678s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001076s ]