SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503072 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503072 [ RunTime:0.002841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474497,749805,739821,941041,582465,251315,285046,900603,785206,122833,729195,854628,78254,754079,129439,492151,437727,849215,469106,435355,441840,241119,327732,919152,434560,477345,839029,452670,772006,473700,787027,24745,450363,375404,298406,310909,667285,160658,907125,297315,525048,816910,917080,401871,996179,189880,855279,849313,426836,111189,214368,231600,212839,932959,168430,219139,523202,12297,556663,387994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]