SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30941 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30941 [ RunTime:0.002068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491726,5345,272596,799500,506181,543989,835740,624413,605473,680554,610930,600990,449370,501580,1014470,889888,549542,347528,1024213,984841,289647,377122,577354,685731,139687,956283,785499,655556,911570,336558,995033,481029,110460,700098,572543,1041507,603443,396543,53821,911720,359336,41247,879643,785482,412007,569201,933086,457512,167901,605365,708773,52030,911605,733603,116412,885690,624739,163159,1017580,773003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]