SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399804 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399804 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728248,604471,72094,989636,136337,735448,917572,302007,86131,975392,750256,722512,713273,285659,603776,921158,238690,638289,688559,516918,948410,704382,539026,895522,508082,331964,369249,176685,6454,1032674,181291,80126,657336,131003,998502,143277,872459,672125,821977,20228,469104,91134,100638,604906,874958,1014720,52206,609958,505608,79857,181343,261642,1038697,381333,477149,423298,490468,902505,543071,770283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002821s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]