SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040873 LIMIT 1 [ RunTime:0.000639s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040873 [ RunTime:0.003424s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419512,105153,454124,936454,994858,126599,253782,920816,988996,633642,445470,629621,845795,535571,944596,117047,908598,833232,157097,160356,981496,604251,84730,810936,211029,719755,320604,1007603,509795,787086,698448,459424,621235,883824,596541,54341,529372,299375,753214,744965,399677,821839,1031386,262474,678455,813617,1041914,201521,725096,548511,809431,805009,96423,627481,5445,114467,260110,537625,291270,246302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040873 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000874s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040873 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]