SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001523s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037675 LIMIT 1 [ RunTime:0.000711s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037675 [ RunTime:0.008693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007908,791498,368694,717584,446666,553973,335769,487537,811125,930048,821794,838572,400621,869885,776192,734631,896859,757561,528387,267652,117256,919751,706566,539114,59884,364117,622618,544175,429070,647149,54626,696321,854599,427071,314619,994946,676880,318819,1012575,742212,204175,1006308,224974,385077,92220,133636,1003929,138700,420911,731989,965503,460155,1010888,685598,520997,345993,119052,500206,919243,520356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037675 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037675 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]