SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406697 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406697 [ RunTime:0.002324s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333180,455982,135901,973902,963449,174071,331925,78712,1024637,996120,65081,418909,944802,976712,55061,632237,562359,49043,301562,669231,471065,836524,58107,16401,354921,42225,429737,832606,656115,642960,171669,861281,706074,483957,726301,737406,500643,375249,49961,4516,2869,165127,645309,166795,398987,155670,912508,352540,911145,908527,481656,1008821,102089,986621,681191,884961,927675,1009027,472571,554927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]