SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046989 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046989 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847502,1029600,1047619,329451,840634,618562,332682,236375,1020407,250048,320637,236243,639252,22001,622654,485291,837641,995114,332051,415582,590765,190739,475173,156945,796540,718996,216406,250399,689060,188809,333128,897762,448249,427901,513814,109278,205145,1008199,424093,697913,1035292,826910,550494,608418,834239,745160,457905,13893,616056,687364,415926,10841,868181,679780,393175,580442,216734,943238,122053,1044335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046989 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046989 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001289s ]