SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 347816 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 347816 [ RunTime:0.002301s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47049,498930,432847,96971,878869,400359,303895,906057,718921,586530,1034333,896176,74634,1015009,284588,880811,404331,240038,639304,131608,293125,565164,10517,638460,122906,590789,414490,771162,478566,408934,288849,194156,221528,362440,175016,993964,226697,204858,48071,446085,533460,511409,120120,179731,975152,32676,395366,567811,925801,169220,820735,442111,34428,688913,983724,885575,76560,1002861,661365,944850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 347816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 347816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]