SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526854 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526854 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (167099,196646,63472,420430,599615,363038,526943,284731,97634,279546,479110,828012,782343,89370,575238,443846,197401,232682,980653,180413,331683,1016314,1044105,396154,581721,99557,586870,918771,1045705,181210,235060,527963,935175,887120,757782,456960,706133,131400,530853,786503,675493,63558,777446,304455,167563,304851,455704,647984,571606,631264,289889,222637,349257,974584,511922,20403,232583,350591,248600,820058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]