SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520842 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520842 [ RunTime:0.002187s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (630556,451337,1046977,895849,916283,29965,349130,631381,227495,525313,595637,43895,346176,999544,586173,757771,614467,76259,604043,958580,555514,769046,997559,11657,131404,169803,586240,170590,964819,298888,424453,915558,386163,103704,955789,732728,417830,565364,113005,713338,55864,681946,493049,871151,816160,791434,205064,240546,38755,899908,153430,295918,203310,102065,883929,149341,348749,169335,539737,743848) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]