SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48850 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48850 [ RunTime:0.002487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874998,236141,318009,458870,898461,833338,217551,860033,647707,83613,297381,453283,527242,574131,769260,560785,342212,47572,358467,967885,884767,200692,213543,136195,211554,681641,855008,590,145529,832584,760410,240579,117477,179451,771989,879866,22678,322555,988128,22914,732330,303594,387763,228005,552917,543417,965144,415879,366549,895841,842239,892933,279918,623512,547659,958436,943441,931364,937910,907218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]