SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44842 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44842 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (931652,1031882,205194,299521,167419,812106,718595,802005,260703,690806,897423,25629,406772,398403,887404,518345,477579,432745,591834,444456,417365,538467,206901,664562,425289,282407,146687,890258,359667,236,80488,1044338,525562,44987,1017554,957309,369039,364662,421485,947639,317069,817014,396125,166060,107854,105384,374503,694860,340180,1036598,219625,75450,286494,933829,251133,402197,258686,347900,879828,657691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]