SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009219 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009219 [ RunTime:0.002458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89893,220663,1004186,928444,771813,57967,29810,968208,566023,1046843,247479,396533,577574,196063,835463,548484,134284,758095,428104,823517,485078,568227,265417,330305,364739,301563,720398,281443,802145,470181,696719,569107,148972,80020,590536,501732,799560,689614,531880,180986,96667,205663,323201,356519,651562,727394,126476,64752,298421,33545,601912,173028,216879,878496,603375,366538,816392,351751,621843,829036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009219 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009219 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]