SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109204 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109204 [ RunTime:0.002763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615774,605499,933150,205623,587001,710178,204854,73803,426326,120441,1025640,203719,844645,534674,816733,142038,336979,156303,139443,355399,751486,17503,49307,555826,336079,438288,415760,6170,804985,189575,1014509,570308,993560,764614,219720,484935,888418,977362,339253,372471,451764,526114,162037,542356,1042404,201916,579839,845995,891810,6599,1001744,739890,31590,236918,798823,417373,728710,354681,1000082,89051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]