SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001904s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491035 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491035 [ RunTime:0.003572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383502,182136,577529,927620,949434,293001,339671,204400,277992,239135,236253,240465,893628,894568,842127,205718,399239,581358,558169,906194,179608,223263,802467,338547,242309,663890,264317,761661,385888,55119,343578,168380,318395,375092,986060,180010,202850,968585,264430,498477,1029790,923824,28359,748587,103234,891686,891804,569367,355484,376886,361589,972992,903014,927072,731777,1028444,272579,909768,839610,830544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003877s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]