SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 353621 LIMIT 1 [ RunTime:0.001972s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 353621 [ RunTime:0.001455s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943633,837853,929968,281114,330183,778414,220477,36484,372214,144179,463341,32160,716299,927410,129896,727632,1008995,583786,543327,801602,486321,914029,462746,807967,106993,328165,1028939,309748,22059,147794,371030,85190,582445,417877,944603,848009,262847,13112,1009743,107592,487505,542055,334931,649117,1019841,783529,382771,366341,641599,265815,975336,548618,682310,1012709,1026880,506080,394625,383652,369418,684417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 353621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 353621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]