SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433243 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433243 [ RunTime:0.002508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (882585,1009882,230843,753239,426925,867227,797219,745769,666175,84967,19254,380823,372142,287144,312495,913224,398462,477152,215959,566326,404738,45475,497981,331131,1004049,309127,50754,690007,804697,401196,102132,22198,472421,797179,610872,188953,909264,241230,503590,946666,602573,323434,338597,745995,221237,636273,531837,783269,796549,464385,932856,618876,100301,408085,23731,281479,620463,609813,455821,161447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]