SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480012 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480012 [ RunTime:0.002453s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (2901,977380,914823,83461,315007,811419,833399,893133,184806,862024,326387,890494,937958,651164,465027,274593,190189,662123,755984,754557,76761,76742,902999,47176,333173,271458,867902,556634,452706,338179,695188,965485,429044,866010,938989,878161,628473,200677,1012797,81442,349009,33110,847046,754901,103815,732574,743313,904572,943026,889449,33251,366687,697703,114715,506091,682399,454233,454557,259955,1039301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015702s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]