SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 97218 LIMIT 1 [ RunTime:0.000592s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 97218 [ RunTime:0.002645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (673120,673547,744886,191601,768,854896,236528,102694,1034843,138504,479373,685496,471340,95634,202312,261950,927529,167767,304755,714130,433443,296302,962837,651703,514888,776434,521312,55972,478271,677768,806115,34764,765872,996225,965341,380764,623077,142281,800726,701566,98829,415261,349970,805080,604734,110702,137262,158040,922955,583388,21831,152917,436181,445742,821683,21764,815824,259686,310851,843982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 97218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 97218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]