SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682857 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682857 [ RunTime:0.002642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (66256,1048414,31768,639960,357473,222550,854218,425873,182638,6991,359545,48562,573913,895944,895889,237019,888949,13334,980649,511366,725200,666057,1021505,304530,790677,532501,440760,130931,475663,730376,729851,704669,150925,401098,876002,969414,342325,123299,415470,204176,774652,115374,335452,69499,457080,512296,649281,344559,749519,265904,622267,453966,204067,751318,35207,269077,757757,1048707,293727,386327) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]