SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398260 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398260 [ RunTime:0.003181s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478205,400590,300881,894332,362949,863233,1001767,686823,913636,505694,229015,965676,943650,14017,714383,854838,696362,217522,240496,346065,237479,918561,125106,975542,416161,905958,1017103,221635,954312,863948,262274,689786,900648,76145,409090,753088,52534,494209,548404,797477,700803,954324,830819,711358,414897,21769,250469,493407,974598,958583,573856,619228,1018625,860348,885109,705524,89407,384856,822144,429377) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398260 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398260 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]