SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437791 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437791 [ RunTime:0.002653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044290,772185,645553,18710,222383,480792,465005,4245,174406,215844,890111,484043,990268,697900,496257,907716,1020384,304181,1016348,383005,513674,691022,982333,885399,121513,747592,974168,199545,862316,16762,37129,932826,123754,103214,913367,480649,137480,360240,299193,174431,365474,659749,794284,396944,798594,39177,494151,929681,321428,396239,256369,197009,290981,707618,915280,915936,148713,8815,951674,500998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000730s ]