SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517393 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517393 [ RunTime:0.001491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007810,727737,182486,985821,702081,748387,1016479,853697,898860,83782,828925,379508,6251,916603,221349,318996,1010899,459157,640631,591031,439346,52153,475334,1019140,812421,791846,716612,171909,3116,343292,438946,412983,810925,880939,363959,724361,40524,818760,1029157,1041952,817548,15211,459052,1009350,39913,816478,889692,738252,171536,991922,825867,641266,880511,378753,314350,91732,669876,1020739,526895,407294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]