SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367156 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367156 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329503,416662,1009151,62462,422393,733790,572094,962932,930708,828988,210817,262459,539632,150962,907140,979587,807850,825319,224672,778681,818384,603555,526643,719278,1018739,544887,516301,717070,794137,833489,455176,564825,965130,514826,1015157,329439,876251,656295,1034666,193363,841083,614116,237812,800762,644392,604462,102996,291377,274946,162841,609620,559290,881418,229952,656790,650501,936283,230373,434390,881220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367156 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367156 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]