SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445579 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445579 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (897655,416335,437218,3793,696434,724437,609287,996967,958774,190568,355788,942246,302487,676116,545854,329871,226185,529590,254757,649805,19045,133564,778358,755941,450338,288249,244802,839212,733958,104836,135394,785434,503303,121215,793843,397903,910905,152530,817017,474921,265989,197453,449879,24912,15675,794917,388802,410075,479469,451537,1006684,541447,909077,709600,772173,14084,128367,92075,125806,47596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445579 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445579 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]