SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028250 LIMIT 1 [ RunTime:0.000654s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028250 [ RunTime:0.002812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846243,282760,623391,738823,991858,710018,756807,767912,233830,641288,561709,661758,645773,159916,652412,540411,589002,415786,410103,247130,726477,727686,15576,265926,388326,227406,358548,301793,237887,905735,719822,529868,552135,668281,728561,901505,81921,239369,89478,443847,592262,867010,780851,17715,658939,917508,494284,516245,481046,771946,123141,219160,541496,1014004,264366,104842,725953,524284,47038,886590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028250 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028250 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]