SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 112474 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 112474 [ RunTime:0.002614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515209,725400,447694,592405,130110,646127,544401,25602,476310,175881,709597,33538,898537,277288,249819,784503,801916,594990,24371,864341,255003,486361,905471,809002,914475,542994,910183,638801,584804,576461,379931,80649,148483,183842,320172,189641,195281,762007,478906,1037582,349272,849782,956115,477441,629038,260856,1035275,368856,676342,883987,432088,377412,363770,444327,526049,66338,973046,934229,318803,858191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 112474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 112474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000916s ]