SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204656 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204656 [ RunTime:0.002346s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (994591,235960,694446,624460,763355,381509,588697,81214,869407,80728,422475,18420,917322,957025,518027,916984,322817,186612,836682,678136,495006,987565,42139,419768,980815,1011952,405688,950354,836541,623965,769377,888208,64601,70623,102451,852990,634459,645544,668496,777762,918372,96710,194501,269164,201759,540102,355201,179933,595007,834122,366405,967774,456290,29353,615860,35887,487379,1005247,134960,246054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204656 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204656 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004650s ]