SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001868s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404578 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404578 [ RunTime:0.003024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440101,437540,98150,991379,81345,1004119,47739,426682,185315,585941,741629,170295,231314,937397,210915,233529,588388,893696,52682,966630,343103,394029,130930,742951,228567,708459,563178,506110,381942,1029900,910369,13854,382412,664319,804644,294987,912870,202837,216890,522530,224232,668971,570672,626400,719103,341125,561833,1038251,974429,851743,96383,724663,1003649,695859,324608,203404,355042,232991,315428,416785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]