SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001534s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45171 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45171 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233173,693460,909261,242890,306014,156586,1013614,281178,614022,326933,374318,250362,551231,244005,458884,879542,672656,177302,331506,981391,720990,406581,428838,891816,243358,210183,582545,732518,725092,73314,547278,992283,461527,400407,507780,981429,567878,855651,159718,28070,245040,462676,216411,281888,388125,386910,977306,673390,1043482,320962,432278,368898,884023,787799,147503,222947,250253,954222,692998,321673) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]