SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549011 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549011 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268081,462497,379865,891625,614556,631788,533522,104521,842407,514910,101974,798728,870719,147130,889651,233159,915713,653573,639430,352281,510916,189159,964834,474999,407497,476140,984196,796248,954365,297835,75785,668338,302756,523270,304012,776519,54657,585164,204354,801769,735864,722197,286287,630246,132428,265887,36803,754082,541938,354729,100340,890339,294634,325178,100268,882024,133450,653597,502339,640824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]