SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311274 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311274 [ RunTime:0.002191s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618024,729245,934405,231147,1016702,473196,131578,623103,480248,1042161,650835,1006938,1041780,943241,156453,146131,189694,203737,1019720,677188,7795,1011634,897245,362662,518001,92180,343571,469538,220751,192450,376619,910507,503474,1024102,72228,367921,904920,867936,272221,142479,241876,649222,213141,979661,654980,104440,721156,508532,443409,591020,1012588,220731,97927,57421,425614,116030,682432,345901,1016774,479074) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311274 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311274 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]