SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505191 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505191 [ RunTime:0.002758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602784,769520,196633,547223,762543,269567,308114,25352,845791,467797,142984,533613,523168,720706,177388,501962,746658,896177,171778,437329,604998,99960,914919,479007,698724,104313,474099,495850,354726,842088,11914,376860,833828,581587,288232,868022,233725,553286,372330,545501,1045744,635716,350719,496604,724937,341843,98332,498173,314897,43282,811601,600335,1031054,530540,784441,449922,516280,548532,1002690,244585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001731s ]