SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029779 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029779 [ RunTime:0.002085s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474727,213637,804658,61766,200922,411453,668435,994572,396661,49184,615046,671418,202890,61535,547531,982822,307364,71165,159918,479373,831012,149289,337461,698496,422435,738129,340760,519193,19490,82739,167498,337633,831794,937804,854969,286186,193093,460841,26734,289088,286572,214739,134835,901158,986282,302548,648937,969113,320969,914514,1041875,852503,69308,597491,237796,480907,228688,702540,879370,812265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029779 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029779 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]