SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536964 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536964 [ RunTime:0.003420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (863997,707929,512980,1041787,234964,333670,803213,481934,634887,929046,527913,983824,601411,462456,641022,336811,662543,523508,159228,132803,477034,729548,954190,1004117,556864,287377,476469,911367,416971,992303,922057,220250,967508,937725,220594,361123,489470,49003,721862,578721,105925,923280,736737,384633,829354,1003924,837790,41744,687464,667439,173551,848183,478885,726706,700227,212984,809196,473547,185908,707156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]