SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491840 LIMIT 1 [ RunTime:0.002035s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491840 [ RunTime:0.003316s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544199,53619,456039,78815,944981,763073,425587,292067,246189,87386,722889,603473,877139,8802,252294,484003,926726,928841,430905,704551,932264,827435,15793,420859,1037995,285950,587254,200083,79615,253939,997746,130415,128515,262947,341770,662965,21867,693388,947185,824217,773068,651978,329521,966322,406566,110950,766254,97539,11155,648959,844389,554408,603653,80734,285212,795972,275584,695072,824821,41803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]