SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505221 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505221 [ RunTime:0.003242s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523036,944968,3498,480854,376707,796930,941112,635167,972477,976025,156023,98314,187262,203205,517872,139709,747527,612097,917914,986351,502712,428351,213177,712448,390351,621249,315689,905407,348804,593413,981884,23013,342016,1016517,926817,88309,441453,460874,59931,67881,143404,643290,545010,417668,6988,345033,342643,560236,510184,791391,523039,430907,151698,36506,363497,765521,642777,756100,180111,802049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]