SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199927 LIMIT 1 [ RunTime:0.001436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199927 [ RunTime:0.002659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204336,893459,1043967,555100,394120,83278,908181,1030876,737744,636753,564475,901556,883320,243992,313857,261219,1017048,775685,571133,796726,730947,164866,577778,340989,1043867,345873,99510,786393,855831,965643,783051,904872,79551,617826,148192,192653,608497,844416,1017909,113153,924713,607479,345443,542482,305665,105252,55181,1022220,124989,920933,797192,535908,713794,340046,422987,515312,542249,945196,36640,44352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199927 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199927 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002416s ]