SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001659s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393781 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393781 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5620,625989,522965,900389,480295,74096,343809,558408,48647,736941,475723,464746,47729,280010,751228,707267,1020364,1448,364332,247829,197204,116039,817771,593523,451783,753335,706356,401084,1010284,293380,14591,776040,139516,230969,328210,869516,299096,96872,839470,699457,1041840,380894,259957,339815,1015172,47380,631808,213327,383892,954297,142551,116892,809329,1024129,216488,613219,584872,683312,831137,341858) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]