SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024380 LIMIT 1 [ RunTime:0.000552s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024380 [ RunTime:0.002094s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530341,482121,95545,1001597,192012,786789,804239,329408,814944,276161,6703,741812,549481,197874,978596,5060,830480,506613,914429,750008,551629,94418,833936,379856,55089,728319,540931,124161,980126,39220,750943,708267,483327,454991,508183,417270,83960,778324,399877,824750,303681,356756,611359,709523,500395,728915,715262,18740,340163,503981,574332,332981,731282,338613,925157,350741,591268,1010072,854444,628191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]