SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291287 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291287 [ RunTime:0.001426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (579203,129896,299459,1015241,521321,808638,941560,662462,1023252,217753,718797,429105,185878,117692,442457,769349,334310,376990,1002725,804740,395690,294462,1021129,119657,523790,357821,427688,378184,110082,346914,572539,992715,855053,100750,493989,520124,158285,422576,516975,732301,684345,516362,850013,531891,739332,21599,334242,877259,141046,820647,876324,511524,999398,151539,241917,116848,451152,818008,154002,235271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291287 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291287 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]