SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981803 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981803 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027113,1022247,416630,1013222,420358,297427,141161,900643,124419,274797,702623,637424,391731,594313,68541,836597,659607,262803,994468,959016,557487,747438,739631,761751,985378,395416,765838,611198,903052,1007307,855823,112061,856318,71196,547985,604536,343148,859534,756387,964465,381667,331693,1044654,895186,81959,9641,654278,43954,415171,920126,692283,572444,407277,201581,119517,689193,402211,597295,179663,696233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]