SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397819 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397819 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409515,13558,844758,452117,851189,669832,718216,228791,218803,214396,157908,123539,275069,246723,304600,1008190,342193,1020130,772502,655738,731972,543011,759988,23959,566162,296186,665665,745351,589545,334630,766058,626668,247320,873316,751820,950193,275937,917858,626542,744706,100143,33788,683167,231047,520983,12165,1017454,323872,633033,1028942,145772,531671,235659,11786,186805,180174,231596,683536,651134,321841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397819 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397819 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]