SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002522s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494040 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494040 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619559,1006923,627107,100961,412257,19289,678865,153790,631327,739182,986408,546140,36098,444404,194106,182795,215237,329266,293033,4530,477059,1043518,605394,985606,388660,100133,987617,199107,272667,900078,846095,55044,414382,359243,839270,393164,745774,339691,592822,838615,890761,824533,336064,90291,327793,161894,135821,437454,560352,757354,151082,154998,393232,193439,533244,79028,328305,520413,646387,850236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]