SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505081 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505081 [ RunTime:0.002747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422626,324924,804521,318378,608454,254012,877049,76280,233033,389145,562767,310998,104744,729572,673063,994829,773283,409191,437869,472156,550656,338143,997387,367198,622845,997589,146075,904907,226526,282384,273056,379305,304800,918204,838358,416889,986549,12158,730418,943668,700437,615774,843225,759006,996961,259579,915693,433043,85931,220388,732065,226047,211639,550358,724879,940684,615143,29806,561875,255738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]