SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413818 LIMIT 1 [ RunTime:0.004278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413818 [ RunTime:0.007659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (625420,930472,365087,359655,697917,871370,979892,108502,480759,979362,568174,884949,754000,462577,1010935,503414,489646,535316,949108,687829,596091,310424,174100,368692,843402,473102,301949,737614,788577,86255,355264,724844,669193,782296,942994,36122,537210,549653,5807,773815,627403,196712,11473,1004731,626477,731267,661109,595248,348876,781235,930056,279985,909508,871412,783511,394065,191691,847029,741782,1030572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001216s ]